Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 9535 |
| Missing cells | 1 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.9 MiB |
| Average record size in memory | 209.2 B |
Variable types
| NUM | 9 |
|---|---|
| CAT | 2 |
Reproduction
| Analysis started | 2020-05-29 03:58:43.774433 |
|---|---|
| Analysis finished | 2020-05-29 03:58:57.802358 |
| Duration | 14.03 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
brand has constant value "Globe Postpaid" | Constant |
unitId has a high cardinality: 9534 distinct values | High cardinality |
sms is highly correlated with voice and 2 other fields | High correlation |
voice is highly correlated with sms and 2 other fields | High correlation |
revenueData is highly correlated with data | High correlation |
data is highly correlated with revenueData | High correlation |
revenueVoice is highly correlated with voice and 2 other fields | High correlation |
revenueSms is highly correlated with voice and 2 other fields | High correlation |
data is highly skewed (γ1 = 80.73443361) | Skewed |
voice is highly skewed (γ1 = 72.47340129) | Skewed |
sms is highly skewed (γ1 = 63.29796917) | Skewed |
revenueData is highly skewed (γ1 = 84.1665927) | Skewed |
revenueVoice is highly skewed (γ1 = 74.61216268) | Skewed |
revenueSms is highly skewed (γ1 = 72.26819623) | Skewed |
unitId is uniformly distributed | Uniform |
voice has 339 (3.6%) zeros | Zeros |
sms has 340 (3.6%) zeros | Zeros |
revenueVoice has 339 (3.6%) zeros | Zeros |
revenueSms has 341 (3.6%) zeros | Zeros |
yieldVoice has 339 (3.6%) zeros | Zeros |
yieldSms has 341 (3.6%) zeros | Zeros |
| Distinct count | 9534 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 74.6 KiB |
| ALROSA | 1 |
|---|---|
| OAKPRMIER | 1 |
| CADIZISLA | 1 |
| SNPOLC | 1 |
| MAHOGNYPLC32TAGNCRPC | 1 |
| Other values (9529) |
| Value | Count | Frequency (%) | |
| ALROSA | 1 | < 0.1% | |
| OAKPRMIER | 1 | < 0.1% | |
| CADIZISLA | 1 | < 0.1% | |
| SNPOLC | 1 | < 0.1% | |
| MAHOGNYPLC32TAGNCRPC | 1 | < 0.1% | |
| NAGKAISAQC | 1 | < 0.1% | |
| MAMBS3 | 1 | < 0.1% | |
| MRTGMACUBA4EM | 1 | < 0.1% | |
| GVALLEYCEBUCEBID | 1 | < 0.1% | |
| SUAREZVIL | 1 | < 0.1% | |
| TUYOBAL | 1 | < 0.1% | |
| CARMENPGSN | 1 | < 0.1% | |
| DUGSO | 1 | < 0.1% | |
| MARKETBGC6LS | 1 | < 0.1% | |
| ANTHNYPLMIO1QCNCRPNP | 1 | < 0.1% | |
| CATALI | 1 | < 0.1% | |
| BELIN | 1 | < 0.1% | |
| KABASA | 1 | < 0.1% | |
| CABARTANCGYN | 1 | < 0.1% | |
| SMNRTHMAIN2 | 1 | < 0.1% | |
| FELIPEPGN | 1 | < 0.1% | |
| STARMALP | 1 | < 0.1% | |
| MARAW2TEMPO | 1 | < 0.1% | |
| BOTOLAWST | 1 | < 0.1% | |
| OOGONG | 1 | < 0.1% | |
| Other values (9509) | 9509 | 99.7% |
Length
| Max length | 25 |
|---|---|
| Median length | 9 |
| Mean length | 9.232721552 |
| Min length | 2 |
Most occurring characters
| Value | Count | Frequency (%) | |
| A | 12909 | 14.7% | |
| N | 6683 | 7.6% | |
| L | 5733 | 6.5% | |
| S | 5142 | 5.8% | |
| I | 5101 | 5.8% | |
| O | 5028 | 5.7% | |
| R | 4800 | 5.5% | |
| C | 4655 | 5.3% | |
| T | 4638 | 5.3% | |
| M | 4282 | 4.9% | |
| E | 4139 | 4.7% | |
| B | 3667 | 4.2% | |
| G | 3419 | 3.9% | |
| U | 3011 | 3.4% | |
| P | 2982 | 3.4% | |
| D | 2694 | 3.1% | |
| Y | 1316 | 1.5% | |
| V | 1177 | 1.3% | |
| H | 1026 | 1.2% | |
| K | 977 | 1.1% | |
| W | 732 | 0.8% | |
| 2 | 696 | 0.8% | |
| Q | 562 | 0.6% | |
| Z | 561 | 0.6% | |
| F | 515 | 0.6% | |
| Other values (18) | 1589 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Uppercase Letter | 86342 | 98.1% | |
| Decimal Number | 1680 | 1.9% | |
| Lowercase Letter | 12 | < 0.1% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| A | 12909 | 15.0% | |
| N | 6683 | 7.7% | |
| L | 5733 | 6.6% | |
| S | 5142 | 6.0% | |
| I | 5101 | 5.9% | |
| O | 5028 | 5.8% | |
| R | 4800 | 5.6% | |
| C | 4655 | 5.4% | |
| T | 4638 | 5.4% | |
| M | 4282 | 5.0% | |
| E | 4139 | 4.8% | |
| B | 3667 | 4.2% | |
| G | 3419 | 4.0% | |
| U | 3011 | 3.5% | |
| P | 2982 | 3.5% | |
| D | 2694 | 3.1% | |
| Y | 1316 | 1.5% | |
| V | 1177 | 1.4% | |
| H | 1026 | 1.2% | |
| K | 977 | 1.1% | |
| W | 732 | 0.8% | |
| Q | 562 | 0.7% | |
| Z | 561 | 0.6% | |
| F | 515 | 0.6% | |
| J | 402 | 0.5% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 2 | 696 | 41.4% | |
| 1 | 463 | 27.6% | |
| 3 | 188 | 11.2% | |
| 4 | 89 | 5.3% | |
| 5 | 61 | 3.6% | |
| 8 | 42 | 2.5% | |
| 0 | 41 | 2.4% | |
| 6 | 38 | 2.3% | |
| 9 | 32 | 1.9% | |
| 7 | 30 | 1.8% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| n | 3 | 25.0% | |
| a | 2 | 16.7% | |
| s | 2 | 16.7% | |
| l | 2 | 16.7% | |
| c | 1 | 8.3% | |
| r | 1 | 8.3% | |
| o | 1 | 8.3% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 86354 | 98.1% | |
| Common | 1680 | 1.9% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| A | 12909 | 14.9% | |
| N | 6683 | 7.7% | |
| L | 5733 | 6.6% | |
| S | 5142 | 6.0% | |
| I | 5101 | 5.9% | |
| O | 5028 | 5.8% | |
| R | 4800 | 5.6% | |
| C | 4655 | 5.4% | |
| T | 4638 | 5.4% | |
| M | 4282 | 5.0% | |
| E | 4139 | 4.8% | |
| B | 3667 | 4.2% | |
| G | 3419 | 4.0% | |
| U | 3011 | 3.5% | |
| P | 2982 | 3.5% | |
| D | 2694 | 3.1% | |
| Y | 1316 | 1.5% | |
| V | 1177 | 1.4% | |
| H | 1026 | 1.2% | |
| K | 977 | 1.1% | |
| W | 732 | 0.8% | |
| Q | 562 | 0.7% | |
| Z | 561 | 0.6% | |
| F | 515 | 0.6% | |
| J | 402 | 0.5% | |
| Other values (8) | 203 | 0.2% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 2 | 696 | 41.4% | |
| 1 | 463 | 27.6% | |
| 3 | 188 | 11.2% | |
| 4 | 89 | 5.3% | |
| 5 | 61 | 3.6% | |
| 8 | 42 | 2.5% | |
| 0 | 41 | 2.4% | |
| 6 | 38 | 2.3% | |
| 9 | 32 | 1.9% | |
| 7 | 30 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 88034 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| A | 12909 | 14.7% | |
| N | 6683 | 7.6% | |
| L | 5733 | 6.5% | |
| S | 5142 | 5.8% | |
| I | 5101 | 5.8% | |
| O | 5028 | 5.7% | |
| R | 4800 | 5.5% | |
| C | 4655 | 5.3% | |
| T | 4638 | 5.3% | |
| M | 4282 | 4.9% | |
| E | 4139 | 4.7% | |
| B | 3667 | 4.2% | |
| G | 3419 | 3.9% | |
| U | 3011 | 3.4% | |
| P | 2982 | 3.4% | |
| D | 2694 | 3.1% | |
| Y | 1316 | 1.5% | |
| V | 1177 | 1.3% | |
| H | 1026 | 1.2% | |
| K | 977 | 1.1% | |
| W | 732 | 0.8% | |
| 2 | 696 | 0.8% | |
| Q | 562 | 0.6% | |
| Z | 561 | 0.6% | |
| F | 515 | 0.6% | |
| Other values (18) | 1589 | 1.8% |
| Distinct count | 9533 |
|---|---|
| Unique (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1215626.4185622784 |
|---|---|
| Minimum | 0.0 |
| Maximum | 460072912.5841356 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Memory size | 74.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 28069.48559 |
| Q1 | 189812.5089 |
| median | 603273.0521 |
| Q3 | 1598149.383 |
| 95-th percentile | 4065049.202 |
| Maximum | 460072912.6 |
| Range | 460072912.6 |
| Interquartile range (IQR) | 1408336.875 |
Descriptive statistics
| Standard deviation | 5026857.232 |
|---|---|
| Coefficient of variation (CV) | 4.135199067 |
| Kurtosis | 7301.721574 |
| Mean | 1215626.419 |
| Median Absolute Deviation (MAD) | 502036.5009 |
| Skewness | 80.73443361 |
| Sum | 1.15909979e+10 |
| Variance | 2.526929363e+13 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 3 | < 0.1% | |
| 2869393.577 | 1 | < 0.1% | |
| 440881.0919 | 1 | < 0.1% | |
| 182620.2731 | 1 | < 0.1% | |
| 146582.5325 | 1 | < 0.1% | |
| 1910976.261 | 1 | < 0.1% | |
| 994283.978 | 1 | < 0.1% | |
| 307288.3958 | 1 | < 0.1% | |
| 1207528.069 | 1 | < 0.1% | |
| 6800799.843 | 1 | < 0.1% | |
| 3230417.601 | 1 | < 0.1% | |
| 1260027.983 | 1 | < 0.1% | |
| 361183.8874 | 1 | < 0.1% | |
| 51823.4143 | 1 | < 0.1% | |
| 62484.23538 | 1 | < 0.1% | |
| 940815.9086 | 1 | < 0.1% | |
| 809856.9897 | 1 | < 0.1% | |
| 267964.7599 | 1 | < 0.1% | |
| 5934675.972 | 1 | < 0.1% | |
| 236155.1141 | 1 | < 0.1% | |
| 2590939.947 | 1 | < 0.1% | |
| 414816.1562 | 1 | < 0.1% | |
| 123704.0611 | 1 | < 0.1% | |
| 5070.143744 | 1 | < 0.1% | |
| 78656.83776 | 1 | < 0.1% | |
| Other values (9508) | 9508 | 99.7% |
| Value | Count | Frequency (%) | |
| 0 | 3 | < 0.1% | |
| 0.0002 | 1 | < 0.1% | |
| 0.003257953989 | 1 | < 0.1% | |
| 0.003624977705 | 1 | < 0.1% | |
| 0.01435921995 | 1 | < 0.1% | |
| 0.0356 | 1 | < 0.1% | |
| 0.4419 | 1 | < 0.1% | |
| 2.46 | 1 | < 0.1% | |
| 4.818091017 | 1 | < 0.1% | |
| 5.387251482 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 460072912.6 | 1 | < 0.1% | |
| 103632207.5 | 1 | < 0.1% | |
| 15136339.26 | 1 | < 0.1% | |
| 14095961.01 | 1 | < 0.1% | |
| 13629971.51 | 1 | < 0.1% | |
| 12825865.83 | 1 | < 0.1% | |
| 12332725.44 | 1 | < 0.1% | |
| 12190113.03 | 1 | < 0.1% | |
| 12117022.02 | 1 | < 0.1% | |
| 11915942.52 | 1 | < 0.1% |
| Distinct count | 8654 |
|---|---|
| Unique (%) | 90.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47916.62905086523 |
|---|---|
| Minimum | 0.0 |
| Maximum | 14206999.0 |
| Zeros | 339 |
| Zeros (%) | 3.6% |
| Memory size | 74.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 529.4 |
| Q1 | 7727 |
| median | 23359 |
| Q3 | 64488 |
| 95-th percentile | 162556.6 |
| Maximum | 14206999 |
| Range | 14206999 |
| Interquartile range (IQR) | 56761 |
Descriptive statistics
| Standard deviation | 161555.8457 |
|---|---|
| Coefficient of variation (CV) | 3.371602904 |
| Kurtosis | 6234.10775 |
| Mean | 47916.62905 |
| Median Absolute Deviation (MAD) | 19374 |
| Skewness | 72.47340129 |
| Sum | 456885058 |
| Variance | 2.610029127e+10 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 339 | 3.6% | |
| 8071 | 4 | < 0.1% | |
| 14360 | 3 | < 0.1% | |
| 7490 | 3 | < 0.1% | |
| 1177 | 3 | < 0.1% | |
| 10279 | 3 | < 0.1% | |
| 55427 | 3 | < 0.1% | |
| 7373 | 3 | < 0.1% | |
| 2923 | 3 | < 0.1% | |
| 8103 | 3 | < 0.1% | |
| 16568 | 3 | < 0.1% | |
| 10715 | 3 | < 0.1% | |
| 12985 | 3 | < 0.1% | |
| 6890 | 3 | < 0.1% | |
| 4229 | 3 | < 0.1% | |
| 15430 | 3 | < 0.1% | |
| 38585 | 3 | < 0.1% | |
| 23279 | 3 | < 0.1% | |
| 2445 | 3 | < 0.1% | |
| 5782 | 3 | < 0.1% | |
| 9890 | 3 | < 0.1% | |
| 11586 | 3 | < 0.1% | |
| 4 | 3 | < 0.1% | |
| 3219 | 3 | < 0.1% | |
| 2661 | 3 | < 0.1% | |
| Other values (8629) | 9123 | 95.7% |
| Value | Count | Frequency (%) | |
| 0 | 339 | 3.6% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 3 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 11 | 2 | < 0.1% | |
| 15 | 1 | < 0.1% | |
| 18 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 14206999 | 1 | < 0.1% | |
| 4175028 | 1 | < 0.1% | |
| 574006 | 1 | < 0.1% | |
| 506824 | 1 | < 0.1% | |
| 486320 | 1 | < 0.1% | |
| 481260 | 1 | < 0.1% | |
| 474821 | 1 | < 0.1% | |
| 466341 | 1 | < 0.1% | |
| 454910 | 1 | < 0.1% | |
| 452991 | 1 | < 0.1% |
| Distinct count | 8661 |
|---|---|
| Unique (%) | 90.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43587.84876769796 |
|---|---|
| Minimum | 0.0 |
| Maximum | 14091514.0 |
| Zeros | 340 |
| Zeros (%) | 3.6% |
| Memory size | 74.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 445.4 |
| Q1 | 8132 |
| median | 22729 |
| Q3 | 53400 |
| 95-th percentile | 141152.8 |
| Maximum | 14091514 |
| Range | 14091514 |
| Interquartile range (IQR) | 45268 |
Descriptive statistics
| Standard deviation | 173540.9394 |
|---|---|
| Coefficient of variation (CV) | 3.981406386 |
| Kurtosis | 4790.685754 |
| Mean | 43587.84877 |
| Median Absolute Deviation (MAD) | 17871 |
| Skewness | 63.29796917 |
| Sum | 415610138 |
| Variance | 3.011645766e+10 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 340 | 3.6% | |
| 5 | 4 | < 0.1% | |
| 1 | 4 | < 0.1% | |
| 14369 | 4 | < 0.1% | |
| 6756 | 3 | < 0.1% | |
| 52 | 3 | < 0.1% | |
| 2439 | 3 | < 0.1% | |
| 2519 | 3 | < 0.1% | |
| 5631 | 3 | < 0.1% | |
| 24123 | 3 | < 0.1% | |
| 55 | 3 | < 0.1% | |
| 8163 | 3 | < 0.1% | |
| 25378 | 3 | < 0.1% | |
| 2565 | 3 | < 0.1% | |
| 31712 | 3 | < 0.1% | |
| 23693 | 3 | < 0.1% | |
| 17295 | 3 | < 0.1% | |
| 15432 | 3 | < 0.1% | |
| 3353 | 3 | < 0.1% | |
| 4464 | 3 | < 0.1% | |
| 10432 | 3 | < 0.1% | |
| 4778 | 3 | < 0.1% | |
| 326 | 3 | < 0.1% | |
| 14929 | 3 | < 0.1% | |
| 20718 | 3 | < 0.1% | |
| Other values (8636) | 9120 | 95.6% |
| Value | Count | Frequency (%) | |
| 0 | 340 | 3.6% | |
| 1 | 4 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 5 | 4 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 12 | 1 | < 0.1% | |
| 13 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 14091514 | 1 | < 0.1% | |
| 7038535 | 1 | < 0.1% | |
| 2801133 | 1 | < 0.1% | |
| 2297384 | 1 | < 0.1% | |
| 1297004 | 1 | < 0.1% | |
| 814713 | 1 | < 0.1% | |
| 682411 | 1 | < 0.1% | |
| 603957 | 1 | < 0.1% | |
| 574939 | 1 | < 0.1% | |
| 572689 | 1 | < 0.1% |
| Distinct count | 9533 |
|---|---|
| Unique (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 102281.65762908757 |
|---|---|
| Minimum | 0.0 |
| Maximum | 48463310.719327524 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Memory size | 74.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2071.404125 |
| Q1 | 13412.2051 |
| median | 42281.24979 |
| Q3 | 127312.3714 |
| 95-th percentile | 360820.4796 |
| Maximum | 48463310.72 |
| Range | 48463310.72 |
| Interquartile range (IQR) | 113900.1663 |
Descriptive statistics
| Standard deviation | 521804.7206 |
|---|---|
| Coefficient of variation (CV) | 5.101645131 |
| Kurtosis | 7751.569353 |
| Mean | 102281.6576 |
| Median Absolute Deviation (MAD) | 35741.90095 |
| Skewness | 84.1665927 |
| Sum | 975255605.5 |
| Variance | 2.722801665e+11 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 3 | < 0.1% | |
| 117736.244 | 1 | < 0.1% | |
| 7164.632883 | 1 | < 0.1% | |
| 55515.05426 | 1 | < 0.1% | |
| 51184.05352 | 1 | < 0.1% | |
| 7725.173499 | 1 | < 0.1% | |
| 490070.0378 | 1 | < 0.1% | |
| 6419.026244 | 1 | < 0.1% | |
| 68504.26526 | 1 | < 0.1% | |
| 69790.80036 | 1 | < 0.1% | |
| 351884.0944 | 1 | < 0.1% | |
| 16372.10443 | 1 | < 0.1% | |
| 66872.70356 | 1 | < 0.1% | |
| 37781.65767 | 1 | < 0.1% | |
| 3711.831788 | 1 | < 0.1% | |
| 13309.42068 | 1 | < 0.1% | |
| 111800.7304 | 1 | < 0.1% | |
| 112261.6978 | 1 | < 0.1% | |
| 41679.74292 | 1 | < 0.1% | |
| 28370.01914 | 1 | < 0.1% | |
| 109360.31 | 1 | < 0.1% | |
| 304513.8858 | 1 | < 0.1% | |
| 64674.18118 | 1 | < 0.1% | |
| 249907.1088 | 1 | < 0.1% | |
| 11757.83897 | 1 | < 0.1% | |
| Other values (9508) | 9508 | 99.7% |
| Value | Count | Frequency (%) | |
| 0 | 3 | < 0.1% | |
| 2.504040395e-05 | 1 | < 0.1% | |
| 6.402567045e-05 | 1 | < 0.1% | |
| 0.0002905025625 | 1 | < 0.1% | |
| 0.0005238211596 | 1 | < 0.1% | |
| 0.01405670917 | 1 | < 0.1% | |
| 0.03894872831 | 1 | < 0.1% | |
| 0.09940846477 | 1 | < 0.1% | |
| 0.2028472807 | 1 | < 0.1% | |
| 0.2144686833 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 48463310.72 | 1 | < 0.1% | |
| 9450038.731 | 1 | < 0.1% | |
| 1597611.998 | 1 | < 0.1% | |
| 1373393.596 | 1 | < 0.1% | |
| 1315284.975 | 1 | < 0.1% | |
| 1290872.838 | 1 | < 0.1% | |
| 1250671.868 | 1 | < 0.1% | |
| 1232616.391 | 1 | < 0.1% | |
| 1213967.778 | 1 | < 0.1% | |
| 1182055.964 | 1 | < 0.1% |
| Distinct count | 9197 |
|---|---|
| Unique (%) | 96.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 78260.85406003485 |
|---|---|
| Minimum | 0.0 |
| Maximum | 26250289.952577807 |
| Zeros | 339 |
| Zeros (%) | 3.6% |
| Memory size | 74.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 789.6341923 |
| Q1 | 10366.88248 |
| median | 34177.67043 |
| Q3 | 101395.6803 |
| 95-th percentile | 276922.7201 |
| Maximum | 26250289.95 |
| Range | 26250289.95 |
| Interquartile range (IQR) | 91028.79779 |
Descriptive statistics
| Standard deviation | 295383.6472 |
|---|---|
| Coefficient of variation (CV) | 3.774347351 |
| Kurtosis | 6503.540562 |
| Mean | 78260.85406 |
| Median Absolute Deviation (MAD) | 29170.12157 |
| Skewness | 74.61216268 |
| Sum | 746217243.5 |
| Variance | 8.725149904e+10 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 339 | 3.6% | |
| 65783.04713 | 1 | < 0.1% | |
| 137938.3661 | 1 | < 0.1% | |
| 103349.1026 | 1 | < 0.1% | |
| 268619.4406 | 1 | < 0.1% | |
| 55627.16452 | 1 | < 0.1% | |
| 113115.0692 | 1 | < 0.1% | |
| 117921.1902 | 1 | < 0.1% | |
| 19219.4758 | 1 | < 0.1% | |
| 5960.194683 | 1 | < 0.1% | |
| 16724.18405 | 1 | < 0.1% | |
| 32999.17076 | 1 | < 0.1% | |
| 6866.07924 | 1 | < 0.1% | |
| 25146.51953 | 1 | < 0.1% | |
| 24251.35712 | 1 | < 0.1% | |
| 119412.0985 | 1 | < 0.1% | |
| 28981.3637 | 1 | < 0.1% | |
| 27755.61171 | 1 | < 0.1% | |
| 46325.68068 | 1 | < 0.1% | |
| 4262.737674 | 1 | < 0.1% | |
| 105156.1647 | 1 | < 0.1% | |
| 5105.879234 | 1 | < 0.1% | |
| 15642.79074 | 1 | < 0.1% | |
| 5007.548863 | 1 | < 0.1% | |
| 23521.13164 | 1 | < 0.1% | |
| Other values (9172) | 9172 | 96.2% |
| Value | Count | Frequency (%) | |
| 0 | 339 | 3.6% | |
| 1.636388979 | 1 | < 0.1% | |
| 3.036840075 | 1 | < 0.1% | |
| 4.698197152 | 1 | < 0.1% | |
| 5.270993783 | 1 | < 0.1% | |
| 5.479317421 | 1 | < 0.1% | |
| 5.772480917 | 1 | < 0.1% | |
| 6.756342262 | 1 | < 0.1% | |
| 8.174346305 | 1 | < 0.1% | |
| 8.751312278 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 26250289.95 | 1 | < 0.1% | |
| 7319870.23 | 1 | < 0.1% | |
| 1010630.166 | 1 | < 0.1% | |
| 965903.9009 | 1 | < 0.1% | |
| 911549.7084 | 1 | < 0.1% | |
| 906463.9131 | 1 | < 0.1% | |
| 890130.185 | 1 | < 0.1% | |
| 854547.9943 | 1 | < 0.1% | |
| 817661.7196 | 1 | < 0.1% | |
| 724160.3882 | 1 | < 0.1% |
| Distinct count | 9195 |
|---|---|
| Unique (%) | 96.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43344.65795142295 |
|---|---|
| Minimum | 0.0 |
| Maximum | 16461943.893021591 |
| Zeros | 341 |
| Zeros (%) | 3.6% |
| Memory size | 74.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 466.008127 |
| Q1 | 8161.680821 |
| median | 22562.90992 |
| Q3 | 54084.16685 |
| 95-th percentile | 140618.2247 |
| Maximum | 16461943.89 |
| Range | 16461943.89 |
| Interquartile range (IQR) | 45922.48603 |
Descriptive statistics
| Standard deviation | 191374.1528 |
|---|---|
| Coefficient of variation (CV) | 4.415172754 |
| Kurtosis | 5912.65453 |
| Mean | 43344.65795 |
| Median Absolute Deviation (MAD) | 17796.63354 |
| Skewness | 72.26819623 |
| Sum | 413291313.6 |
| Variance | 3.662406636e+10 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 341 | 3.6% | |
| 6713.168991 | 1 | < 0.1% | |
| 9121.834272 | 1 | < 0.1% | |
| 108032.4699 | 1 | < 0.1% | |
| 23139.27764 | 1 | < 0.1% | |
| 18422.1685 | 1 | < 0.1% | |
| 47375.19937 | 1 | < 0.1% | |
| 33315.39542 | 1 | < 0.1% | |
| 41428.43012 | 1 | < 0.1% | |
| 8952.502611 | 1 | < 0.1% | |
| 46641.3112 | 1 | < 0.1% | |
| 38854.2968 | 1 | < 0.1% | |
| 10679.923 | 1 | < 0.1% | |
| 37346.80643 | 1 | < 0.1% | |
| 68385.34132 | 1 | < 0.1% | |
| 6251.543266 | 1 | < 0.1% | |
| 11186.15016 | 1 | < 0.1% | |
| 53743.11988 | 1 | < 0.1% | |
| 23336.47169 | 1 | < 0.1% | |
| 12304.31588 | 1 | < 0.1% | |
| 67750.43551 | 1 | < 0.1% | |
| 8956.85207 | 1 | < 0.1% | |
| 393.7899383 | 1 | < 0.1% | |
| 932.5449709 | 1 | < 0.1% | |
| 17399.81488 | 1 | < 0.1% | |
| Other values (9170) | 9170 | 96.2% |
| Value | Count | Frequency (%) | |
| 0 | 341 | 3.6% | |
| 0.3028445012 | 1 | < 0.1% | |
| 0.3565134939 | 1 | < 0.1% | |
| 0.6149415539 | 1 | < 0.1% | |
| 0.7078640772 | 1 | < 0.1% | |
| 0.7517773557 | 1 | < 0.1% | |
| 0.7664527623 | 1 | < 0.1% | |
| 1.334197071 | 1 | < 0.1% | |
| 2.594708051 | 1 | < 0.1% | |
| 3.171293533 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 16461943.89 | 1 | < 0.1% | |
| 7402826.828 | 1 | < 0.1% | |
| 675157.3147 | 1 | < 0.1% | |
| 593481.0556 | 1 | < 0.1% | |
| 536241.3485 | 1 | < 0.1% | |
| 514052.8727 | 1 | < 0.1% | |
| 420743.8862 | 1 | < 0.1% | |
| 413686.0816 | 1 | < 0.1% | |
| 412848.2401 | 1 | < 0.1% | |
| 410054.7734 | 1 | < 0.1% |
yieldData
Real number (ℝ≥0)
| Distinct count | 9533 |
|---|---|
| Unique (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.08065083580692169 |
|---|---|
| Minimum | 0.0 |
| Maximum | 0.43712611103826243 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Memory size | 74.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.03605035148 |
| Q1 | 0.0661258899 |
| median | 0.08284541535 |
| Q3 | 0.0963429919 |
| 95-th percentile | 0.1146795279 |
| Maximum | 0.437126111 |
| Range | 0.437126111 |
| Interquartile range (IQR) | 0.030217102 |
Descriptive statistics
| Standard deviation | 0.02584305282 |
|---|---|
| Coefficient of variation (CV) | 0.3204313082 |
| Kurtosis | 15.8230408 |
| Mean | 0.08065083581 |
| Median Absolute Deviation (MAD) | 0.01483369317 |
| Skewness | 1.110043812 |
| Sum | 769.0057194 |
| Variance | 0.0006678633792 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 3 | < 0.1% | |
| 0.115525459 | 1 | < 0.1% | |
| 0.09805510285 | 1 | < 0.1% | |
| 0.09748723422 | 1 | < 0.1% | |
| 0.08848699305 | 1 | < 0.1% | |
| 0.07797106298 | 1 | < 0.1% | |
| 0.09306934957 | 1 | < 0.1% | |
| 0.06615716211 | 1 | < 0.1% | |
| 0.07459637087 | 1 | < 0.1% | |
| 0.04976058736 | 1 | < 0.1% | |
| 0.07970706459 | 1 | < 0.1% | |
| 0.06967123278 | 1 | < 0.1% | |
| 0.08766378073 | 1 | < 0.1% | |
| 0.0224349991 | 1 | < 0.1% | |
| 0.1075270475 | 1 | < 0.1% | |
| 0.07139985212 | 1 | < 0.1% | |
| 0.09848348801 | 1 | < 0.1% | |
| 0.06416877338 | 1 | < 0.1% | |
| 0.1051002205 | 1 | < 0.1% | |
| 0.02066814592 | 1 | < 0.1% | |
| 0.07995517364 | 1 | < 0.1% | |
| 0.07922381681 | 1 | < 0.1% | |
| 0.05219125294 | 1 | < 0.1% | |
| 0.02691264095 | 1 | < 0.1% | |
| 0.1171608119 | 1 | < 0.1% | |
| Other values (9508) | 9508 | 99.7% |
| Value | Count | Frequency (%) | |
| 0 | 3 | < 0.1% | |
| 0.001641864928 | 1 | < 0.1% | |
| 0.004017291903 | 1 | < 0.1% | |
| 0.004089341457 | 1 | < 0.1% | |
| 0.005218688197 | 1 | < 0.1% | |
| 0.005254884635 | 1 | < 0.1% | |
| 0.005369311727 | 1 | < 0.1% | |
| 0.005612479351 | 1 | < 0.1% | |
| 0.005713621206 | 1 | < 0.1% | |
| 0.006065799556 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.437126111 | 1 | < 0.1% | |
| 0.4333111622 | 1 | < 0.1% | |
| 0.4068540051 | 1 | < 0.1% | |
| 0.3948513811 | 1 | < 0.1% | |
| 0.3506163755 | 1 | < 0.1% | |
| 0.2826275944 | 1 | < 0.1% | |
| 0.2745596031 | 1 | < 0.1% | |
| 0.2650946074 | 1 | < 0.1% | |
| 0.2646700628 | 1 | < 0.1% | |
| 0.2572115941 | 1 | < 0.1% |
| Distinct count | 9197 |
|---|---|
| Unique (%) | 96.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.494134533112287 |
|---|---|
| Minimum | 0.0 |
| Maximum | 6.972767275184185 |
| Zeros | 339 |
| Zeros (%) | 3.6% |
| Memory size | 74.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.73713071 |
| Q1 | 1.212426442 |
| median | 1.529956326 |
| Q3 | 1.804382707 |
| 95-th percentile | 2.183581009 |
| Maximum | 6.972767275 |
| Range | 6.972767275 |
| Interquartile range (IQR) | 0.5919562647 |
Descriptive statistics
| Standard deviation | 0.5098552061 |
|---|---|
| Coefficient of variation (CV) | 0.3412378168 |
| Kurtosis | 5.287315072 |
| Mean | 1.494134533 |
| Median Absolute Deviation (MAD) | 0.2953246768 |
| Skewness | -0.03107619051 |
| Sum | 14246.57277 |
| Variance | 0.2599523311 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 339 | 3.6% | |
| 1.230271526 | 1 | < 0.1% | |
| 1.270814896 | 1 | < 0.1% | |
| 1.51240974 | 1 | < 0.1% | |
| 1.447282235 | 1 | < 0.1% | |
| 1.646515209 | 1 | < 0.1% | |
| 2.06757529 | 1 | < 0.1% | |
| 1.19780376 | 1 | < 0.1% | |
| 1.233693211 | 1 | < 0.1% | |
| 1.582114988 | 1 | < 0.1% | |
| 1.635183058 | 1 | < 0.1% | |
| 1.785521145 | 1 | < 0.1% | |
| 1.278940882 | 1 | < 0.1% | |
| 0.9961134318 | 1 | < 0.1% | |
| 1.601642496 | 1 | < 0.1% | |
| 1.234548451 | 1 | < 0.1% | |
| 1.09292461 | 1 | < 0.1% | |
| 1.395799588 | 1 | < 0.1% | |
| 1.673422271 | 1 | < 0.1% | |
| 1.46385743 | 1 | < 0.1% | |
| 1.777027333 | 1 | < 0.1% | |
| 1.365133933 | 1 | < 0.1% | |
| 1.718985909 | 1 | < 0.1% | |
| 1.928300267 | 1 | < 0.1% | |
| 1.329672701 | 1 | < 0.1% | |
| Other values (9172) | 9172 | 96.2% |
| Value | Count | Frequency (%) | |
| 0 | 339 | 3.6% | |
| 0.1645138002 | 1 | < 0.1% | |
| 0.1949658628 | 1 | < 0.1% | |
| 0.2677352134 | 1 | < 0.1% | |
| 0.2775204228 | 1 | < 0.1% | |
| 0.3461304439 | 1 | < 0.1% | |
| 0.3611603279 | 1 | < 0.1% | |
| 0.3611826619 | 1 | < 0.1% | |
| 0.3685176667 | 1 | < 0.1% | |
| 0.3848194961 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6.972767275 | 1 | < 0.1% | |
| 5.825398008 | 1 | < 0.1% | |
| 5.7767218 | 1 | < 0.1% | |
| 5.509700386 | 1 | < 0.1% | |
| 4.87021427 | 1 | < 0.1% | |
| 4.601509004 | 1 | < 0.1% | |
| 4.577418909 | 1 | < 0.1% | |
| 4.466723101 | 1 | < 0.1% | |
| 4.44300812 | 1 | < 0.1% | |
| 4.377098834 | 1 | < 0.1% |
| Distinct count | 9195 |
|---|---|
| Unique (%) | 96.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0382358046302587 |
|---|---|
| Minimum | 0.0 |
| Maximum | 14.809171701892977 |
| Zeros | 341 |
| Zeros (%) | 3.6% |
| Memory size | 74.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.3534750182 |
| Q1 | 0.7953351544 |
| median | 1.042576073 |
| Q3 | 1.271202207 |
| 95-th percentile | 1.666137849 |
| Maximum | 14.8091717 |
| Range | 14.8091717 |
| Interquartile range (IQR) | 0.4758670528 |
Descriptive statistics
| Standard deviation | 0.4546035017 |
|---|---|
| Coefficient of variation (CV) | 0.4378615143 |
| Kurtosis | 100.0199938 |
| Mean | 1.038235805 |
| Median Absolute Deviation (MAD) | 0.2375086692 |
| Skewness | 3.898864749 |
| Sum | 9899.578397 |
| Variance | 0.2066643437 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 341 | 3.6% | |
| 0.8451711761 | 1 | < 0.1% | |
| 1.13124438 | 1 | < 0.1% | |
| 1.068886677 | 1 | < 0.1% | |
| 1.193668902 | 1 | < 0.1% | |
| 1.062154031 | 1 | < 0.1% | |
| 0.5411324308 | 1 | < 0.1% | |
| 1.145278597 | 1 | < 0.1% | |
| 1.067857045 | 1 | < 0.1% | |
| 1.360501717 | 1 | < 0.1% | |
| 0.9397429728 | 1 | < 0.1% | |
| 1.09169116 | 1 | < 0.1% | |
| 1.724740981 | 1 | < 0.1% | |
| 0.5491553624 | 1 | < 0.1% | |
| 1.541233048 | 1 | < 0.1% | |
| 1.405306288 | 1 | < 0.1% | |
| 1.188128891 | 1 | < 0.1% | |
| 1.266753765 | 1 | < 0.1% | |
| 0.85721058 | 1 | < 0.1% | |
| 1.695325678 | 1 | < 0.1% | |
| 0.8911713897 | 1 | < 0.1% | |
| 0.7021599058 | 1 | < 0.1% | |
| 1.106438159 | 1 | < 0.1% | |
| 1.073442917 | 1 | < 0.1% | |
| 0.6621403872 | 1 | < 0.1% | |
| Other values (9170) | 9170 | 96.2% |
| Value | Count | Frequency (%) | |
| 0 | 341 | 3.6% | |
| 0.006975021641 | 1 | < 0.1% | |
| 0.02285047623 | 1 | < 0.1% | |
| 0.03370715409 | 1 | < 0.1% | |
| 0.0500077852 | 1 | < 0.1% | |
| 0.06142294766 | 1 | < 0.1% | |
| 0.0697682299 | 1 | < 0.1% | |
| 0.0747609786 | 1 | < 0.1% | |
| 0.07667075922 | 1 | < 0.1% | |
| 0.07686769424 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 14.8091717 | 1 | < 0.1% | |
| 7.973375588 | 1 | < 0.1% | |
| 6.699522746 | 1 | < 0.1% | |
| 6.61124299 | 1 | < 0.1% | |
| 4.169266832 | 1 | < 0.1% | |
| 3.84134821 | 1 | < 0.1% | |
| 3.690909799 | 1 | < 0.1% | |
| 3.496305805 | 1 | < 0.1% | |
| 3.296143302 | 1 | < 0.1% | |
| 3.286529166 | 1 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 74.6 KiB |
| Globe Postpaid |
|---|
| Value | Count | Frequency (%) | |
| Globe Postpaid | 9535 | 100.0% |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Most occurring characters
| Value | Count | Frequency (%) | |
| o | 19070 | 14.3% | |
| G | 9535 | 7.1% | |
| l | 9535 | 7.1% | |
| b | 9535 | 7.1% | |
| e | 9535 | 7.1% | |
| 9535 | 7.1% | ||
| P | 9535 | 7.1% | |
| s | 9535 | 7.1% | |
| t | 9535 | 7.1% | |
| p | 9535 | 7.1% | |
| a | 9535 | 7.1% | |
| i | 9535 | 7.1% | |
| d | 9535 | 7.1% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 104885 | 78.6% | |
| Uppercase Letter | 19070 | 14.3% | |
| Space Separator | 9535 | 7.1% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| G | 9535 | 50.0% | |
| P | 9535 | 50.0% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| o | 19070 | 18.2% | |
| l | 9535 | 9.1% | |
| b | 9535 | 9.1% | |
| e | 9535 | 9.1% | |
| s | 9535 | 9.1% | |
| t | 9535 | 9.1% | |
| p | 9535 | 9.1% | |
| a | 9535 | 9.1% | |
| i | 9535 | 9.1% | |
| d | 9535 | 9.1% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 9535 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 123955 | 92.9% | |
| Common | 9535 | 7.1% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| o | 19070 | 15.4% | |
| G | 9535 | 7.7% | |
| l | 9535 | 7.7% | |
| b | 9535 | 7.7% | |
| e | 9535 | 7.7% | |
| P | 9535 | 7.7% | |
| s | 9535 | 7.7% | |
| t | 9535 | 7.7% | |
| p | 9535 | 7.7% | |
| a | 9535 | 7.7% | |
| i | 9535 | 7.7% | |
| d | 9535 | 7.7% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 9535 | 100.0% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 133490 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| o | 19070 | 14.3% | |
| G | 9535 | 7.1% | |
| l | 9535 | 7.1% | |
| b | 9535 | 7.1% | |
| e | 9535 | 7.1% | |
| 9535 | 7.1% | ||
| P | 9535 | 7.1% | |
| s | 9535 | 7.1% | |
| t | 9535 | 7.1% | |
| p | 9535 | 7.1% | |
| a | 9535 | 7.1% | |
| i | 9535 | 7.1% | |
| d | 9535 | 7.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| unitId | data | voice | sms | revenueData | revenueVoice | revenueSms | yieldData | yieldVoice | yieldSms | brand | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | SSHMERV | 2.642389e+05 | 77606.0 | 73854.0 | 25287.821183 | 160626.722847 | 95043.330219 | 0.095701 | 2.069772 | 1.286908 | Globe Postpaid |
| 1 | MATANAGALB | 2.556839e+05 | 42512.0 | 89443.0 | 19224.403832 | 50309.994865 | 90323.071962 | 0.075188 | 1.183430 | 1.009839 | Globe Postpaid |
| 2 | SMCSJOAQUINMEXICOPAM | 5.084695e+05 | 25834.0 | 47350.0 | 44462.038089 | 38250.084671 | 35951.820952 | 0.087443 | 1.480610 | 0.759278 | Globe Postpaid |
| 3 | LEISURBAK | 1.408795e+06 | 46590.0 | 19744.0 | 99498.045395 | 78679.873961 | 15167.822524 | 0.070626 | 1.688772 | 0.768224 | Globe Postpaid |
| 4 | LLOREN | 4.079642e+05 | 15639.0 | 7410.0 | 29377.971735 | 15272.088500 | 8199.121962 | 0.072011 | 0.976539 | 1.106494 | Globe Postpaid |
| 5 | KBASAL | 4.705469e+04 | 3874.0 | 6355.0 | 2750.954327 | 4706.095911 | 3566.425025 | 0.058463 | 1.214790 | 0.561200 | Globe Postpaid |
| 6 | BAGUMNAVO | 8.018752e+05 | 32425.0 | 18827.0 | 74960.918148 | 56289.687065 | 25650.260174 | 0.093482 | 1.735997 | 1.362419 | Globe Postpaid |
| 7 | KUKUNHTLCDOD | 8.750528e+06 | 330372.0 | 172000.0 | 546186.367247 | 455157.778599 | 83694.504365 | 0.062418 | 1.377713 | 0.486596 | Globe Postpaid |
| 8 | SMCTATALARZL | 1.509839e+05 | 5417.0 | 844.0 | 14709.588772 | 5866.504766 | 1502.231849 | 0.097425 | 1.082980 | 1.779896 | Globe Postpaid |
| 9 | COLUMBIAQC | 4.804278e+06 | 229994.0 | 92904.0 | 507590.844744 | 474364.984057 | 112547.549639 | 0.105654 | 2.062510 | 1.211439 | Globe Postpaid |
Last rows
| unitId | data | voice | sms | revenueData | revenueVoice | revenueSms | yieldData | yieldVoice | yieldSms | brand | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 9525 | HAWAII | 7.690597e+05 | 10377.0 | 15936.0 | 45118.970386 | 18811.850233 | 20046.681353 | 0.058668 | 1.812841 | 1.257949 | Globe Postpaid |
| 9526 | PIGKAW | 1.441289e+06 | 27349.0 | 32885.0 | 68663.817921 | 30034.360462 | 25646.327648 | 0.047641 | 1.098189 | 0.779879 | Globe Postpaid |
| 9527 | EASTOCEAN6PQUENCRPNP | 4.330816e+04 | 0.0 | 0.0 | 5131.819351 | 0.000000 | 0.000000 | 0.118495 | 0.000000 | 0.000000 | Globe Postpaid |
| 9528 | GATEWAYTWR | 1.133930e+06 | 43263.0 | 79281.0 | 109330.579918 | 84217.586132 | 92803.595850 | 0.096417 | 1.946642 | 1.170565 | Globe Postpaid |
| 9529 | ORIENTSQ | 7.748339e+05 | 26249.0 | 16259.0 | 97510.703407 | 57691.380880 | 20353.561339 | 0.125847 | 2.197851 | 1.251834 | Globe Postpaid |
| 9530 | CABANT | 1.586399e+06 | 56750.0 | 38898.0 | 101224.369841 | 90330.676325 | 42603.150284 | 0.063808 | 1.591730 | 1.095253 | Globe Postpaid |
| 9531 | TALIM | 1.662177e+06 | 41746.0 | 40796.0 | 132522.084959 | 76333.166528 | 49787.282521 | 0.079728 | 1.828515 | 1.220396 | Globe Postpaid |
| 9532 | SERENDST2A | 4.377347e+05 | 16168.0 | 6927.0 | 43259.234120 | 37797.686017 | 5968.647331 | 0.098825 | 2.337808 | 0.861650 | Globe Postpaid |
| 9533 | CASERE | 2.413473e+05 | 4152.0 | 10185.0 | 24130.919826 | 8627.264073 | 15067.913408 | 0.099984 | 2.077857 | 1.479422 | Globe Postpaid |
| 9534 | DUMRAN | 8.518350e+04 | 4704.0 | 5064.0 | 6516.388210 | 5451.543437 | 2068.280732 | 0.076498 | 1.158917 | 0.408428 | Globe Postpaid |